FaSscr001

EntityType | Independent
Logical Entity Name | FaSscr001
Default Table Name | FaSscr001
Logical Only | NO
Owner | dbo
Definition |
Note |

FaSscr001 Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaSscr001Id |  | CHAR(10) | NO |
SSN |  | CHAR(10) | YES |
SchoolCode |  | CHAR(10) | YES |
SchoolBranchCode |  | CHAR(10) | YES |
MoveToSchoolBranchCode |  | CHAR(10) | YES |
SSNIndicator |  | CHAR(10) | YES |
FirstName |  | CHAR(10) | YES |
LastName |  | CHAR(10) | YES |
MiddleName |  | CHAR(10) | YES |
DOB |  | CHAR(10) | YES |
BranchDesignatorCode |  | CHAR(10) | YES |
CertificationDate |  | CHAR(10) | YES |
EnrollmentEffectiveDate |  | CHAR(10) | YES |
EnrollmentStatus |  | CHAR(10) | YES |
AnticipatedCompletionDate |  | CHAR(10) | YES |
TermBeginDate |  | CHAR(10) | YES |
TermEndDate |  | CHAR(10) | YES |
AddressEffectiveDate |  | CHAR(10) | YES |
GoodAddressFlag |  | CHAR(10) | YES |
StreetAddr1 |  | CHAR(10) | YES |
StreetAddr2 |  | CHAR(10) | YES |
City |  | CHAR(10) | YES |
State |  | CHAR(10) | YES |
Country |  | CHAR(10) | YES |
PostalCode |  | CHAR(10) | YES |
PhoneType |  | CHAR(10) | YES |
PhoneNumberFlag |  | CHAR(10) | YES |
PhoneCountryCode |  | CHAR(10) | YES |
PhoneNumber |  | CHAR(10) | YES |
OldLastName |  | CHAR(10) | YES |
OldFirstName |  | CHAR(10) | YES |
OldMiddleName |  | CHAR(10) | YES |
OldDOB |  | CHAR(10) | YES |
OldEnrollmentStatus |  | CHAR(10) | YES |
OldAnticipatedCompletionDate |  | CHAR(10) | YES |
OldEnrollmentEffectiveDate |  | CHAR(10) | YES |
SyStudentId |  | CHAR(10) | YES |
SyCampusId |  | CHAR(10) | YES |
SySchoolStatusId |  | CHAR(10) | YES |
AdEnrollId |  | CHAR(10) | YES |
AttStatID |  | CHAR(10) | YES |
AdTermID |  | CHAR(10) | YES |
ClockCredit |  | CHAR(10) | YES |
TermCreditsSched |  | CHAR(10) | YES |
TermHoursSched |  | CHAR(10) | YES |
BatchId |  | CHAR(10) | YES |
ProgramIndicator |  | CHAR(10) | YES |
IsAddedToFile |  | CHAR(10) | YES |
UserId |  | INTEGER | NO |
DateAdded |  | CHAR(10) | NO |
DateLstMod |  | CHAR(10) | NO |
Ts |  | CHAR(10) | NO |
TermCode |  | CHAR(10) | YES |
OPEID |  | CHAR(10) | YES |
FaBatchExpImpId |  | INTEGER | YES |

FaSscr001 Keys

Key Name | Key Type | Keys
PK_FaSscr001_FaSscr001Id | PrimaryKey | FaSscr001Id
Nk_FaSscr001_SSN_INCL_44_45_50_53 | Inversion Entry | SSN
NCL_FaSSCR001_FaBatchExpImpId_SyStudentID_INCL | Inversion Entry | FaBatchExpImpId, SyStudentId

FaSscr001 Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
FaExportImportFile | Non-Identifying | Zero or One to Zero or More |  |  |  | FaBatchExpImpId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | UserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
FaSscr002 | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaSscr003 | Non-Identifying | One To Zero or More |  |  |  |  | NO

FaSscr001 Check Constraints

Check Constraint Name | CheckConstraint

FaSscr001 Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaSscr001 | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

FaSscr001 Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model

FaSscr001 Data Movement Rules

Name | Type | Rule Text/Value